Overview

Brought to you by YData

Dataset statistics

Number of variables	44
Number of observations	141250
Missing cells	443060
Missing cells (%)	7.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	270.7 MiB
Average record size in memory	2.0 KiB

Variable types

Categorical	18
DateTime	4
Text	9
Numeric	8
Unsupported	2
Boolean	3

Alerts

`GW_Transaction_Status` has constant value "settled"	Constant
`GW_Response` has constant value "Approved"	Constant
`GW_Trx_Type` has constant value "payment"	Constant
`MP_Trx_Type` has constant value "payment"	Constant
`Bank_Debits` has constant value "0.0"	Constant
`BS_Amount` is highly overall correlated with `BS_GW_Match` and 8 other fields	High correlation
`BS_Card_Type` is highly overall correlated with `BS_Payment_Gateway` and 5 other fields	High correlation
`BS_Currency` is highly overall correlated with `BS_Foreign_Exchange_Rate` and 3 other fields	High correlation
`BS_Foreign_Exchange_Rate` is highly overall correlated with `BS_Currency` and 3 other fields	High correlation
`BS_GW_Match` is highly overall correlated with `BS_Amount` and 16 other fields	High correlation
`BS_Payment_Gateway` is highly overall correlated with `BS_Card_Type` and 7 other fields	High correlation
`BS_Payment_Method_Type` is highly overall correlated with `BS_Card_Type` and 7 other fields	High correlation
`BS_Processor_Response_Message` is highly overall correlated with `BS_Amount` and 10 other fields	High correlation
`BS_Record_Type` is highly overall correlated with `BS_Amount` and 10 other fields	High correlation
`Bank_Credits` is highly overall correlated with `BS_GW_Match` and 7 other fields	High correlation
`Bank_Deposit_Currency` is highly overall correlated with `BS_Currency` and 8 other fields	High correlation
`GW_Card_Brand` is highly overall correlated with `BS_Card_Type` and 6 other fields	High correlation
`GW_Net_Settled_Amt` is highly overall correlated with `BS_Amount` and 4 other fields	High correlation
`GW_Transaction_Amount` is highly overall correlated with `BS_Amount` and 4 other fields	High correlation
`GW_Trx_Currency` is highly overall correlated with `BS_Currency` and 4 other fields	High correlation
`GW_fees` is highly overall correlated with `BS_Amount` and 8 other fields	High correlation
`GW_name` is highly overall correlated with `BS_Card_Type` and 8 other fields	High correlation
`MP_Processor_Fee` is highly overall correlated with `BS_Card_Type` and 10 other fields	High correlation
`MP_Processor_Type` is highly overall correlated with `BS_Card_Type` and 9 other fields	High correlation
`MP_Settled_Amount` is highly overall correlated with `BS_Amount` and 7 other fields	High correlation
`MP_Trx_Currency` is highly overall correlated with `BS_Currency` and 7 other fields	High correlation
`PG_MP_Match` is highly overall correlated with `BS_Amount` and 10 other fields	High correlation
`end_to_end_recon_match` is highly overall correlated with `BS_Amount` and 6 other fields	High correlation
`BS_Record_Type` is highly imbalanced (68.6%)	Imbalance
`BS_Processor_Response_Message` is highly imbalanced (68.6%)	Imbalance
`BS_GW_Match` is highly imbalanced (51.2%)	Imbalance
`GW_Transaction_ID` has 15000 (10.6%) missing values	Missing
`GW_name` has 15000 (10.6%) missing values	Missing
`GW_Transaction_Status` has 15000 (10.6%) missing values	Missing
`GW_Response_Code` has 15000 (10.6%) missing values	Missing
`GW_Response` has 15000 (10.6%) missing values	Missing
`GW_Transaction_Amount` has 15000 (10.6%) missing values	Missing
`GW_Trx_Currency` has 15000 (10.6%) missing values	Missing
`GW_Trx_Type` has 15000 (10.6%) missing values	Missing
`GW_Card_Brand` has 15000 (10.6%) missing values	Missing
`GW_fees` has 15000 (10.6%) missing values	Missing
`GW_Net_Settled_Amt` has 15000 (10.6%) missing values	Missing
`GW_Trx_Date` has 15000 (10.6%) missing values	Missing
`GW_Ref_Number` has 15000 (10.6%) missing values	Missing
`MP_Trx_ID` has 16250 (11.5%) missing values	Missing
`MP_Processor_Type` has 16250 (11.5%) missing values	Missing
`MP_Trx_Type` has 16250 (11.5%) missing values	Missing
`MP_Processor_Fee` has 16250 (11.5%) missing values	Missing
`MP_Settled_Amount` has 16250 (11.5%) missing values	Missing
`MP_Settlement_Date` has 16250 (11.5%) missing values	Missing
`MP_Settlement_Batch` has 16250 (11.5%) missing values	Missing
`MP_Trx_Currency` has 16250 (11.5%) missing values	Missing
`MP_Order_ID` has 16250 (11.5%) missing values	Missing
`Bank_Deposit_Date` has 20362 (14.4%) missing values	Missing
`Bank_Deposit_Currency` has 20362 (14.4%) missing values	Missing
`Bank_Deposit_Ref_Number` has 20362 (14.4%) missing values	Missing
`Bank_Credits` has 20362 (14.4%) missing values	Missing
`Bank_Debits` has 20362 (14.4%) missing values	Missing
`BS_Processor_Response_Code` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`GW_Response_Code` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`MP_Processor_Fee` has 83229 (58.9%) zeros	Zeros

Reproduction

Analysis started	2025-07-06 23:53:51.070235
Analysis finished	2025-07-06 23:54:05.118796
Duration	14.05 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

BS_Record_Type
Categorical

High correlation Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

payment	125000
refund	12500
chargeback	2500
chargeback_reversal	1250

Length

Max length	19
Median length	7
Mean length	7.0707965
Min length	6

Characters and Unicode

Total characters	998750
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	payment
2nd row	payment
3rd row	payment
4th row	payment
5th row	payment

Common Values

Value	Count	Frequency (%)
payment	125000	88.5%
refund	12500	8.8%
chargeback	2500	1.8%
chargeback_reversal	1250	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
payment	125000	88.5%
refund	12500	8.8%
chargeback	2500	1.8%
chargeback_reversal	1250	0.9%

Most occurring characters

Value	Count	Frequency (%)
e	143750	14.4%
n	137500	13.8%
a	133750	13.4%
p	125000	12.5%
y	125000	12.5%
m	125000	12.5%
t	125000	12.5%
r	18750	1.9%
u	12500	1.3%
d	12500	1.3%
Other values (10)	40000	4.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	998750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	143750	14.4%
n	137500	13.8%
a	133750	13.4%
p	125000	12.5%
y	125000	12.5%
m	125000	12.5%
t	125000	12.5%
r	18750	1.9%
u	12500	1.3%
d	12500	1.3%
Other values (10)	40000	4.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	998750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	143750	14.4%
n	137500	13.8%
a	133750	13.4%
p	125000	12.5%
y	125000	12.5%
m	125000	12.5%
t	125000	12.5%
r	18750	1.9%
u	12500	1.3%
d	12500	1.3%
Other values (10)	40000	4.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	998750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	143750	14.4%
n	137500	13.8%
a	133750	13.4%
p	125000	12.5%
y	125000	12.5%
m	125000	12.5%
t	125000	12.5%
r	18750	1.9%
u	12500	1.3%
d	12500	1.3%
Other values (10)	40000	4.0%

BS_Transaction_Date
Date

Distinct	90
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.1 MiB

Minimum	2025-01-01 00:00:00
Maximum	2025-03-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

BS_Currency
Categorical

High correlation

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.0 MiB

USD	84784
EUR	21002
GBP	14100
AUD	11416
CAD	9948

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	423750
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	USD
2nd row	USD
3rd row	USD
4th row	GBP
5th row	USD

Common Values

Value	Count	Frequency (%)
USD	84784	60.0%
EUR	21002	14.9%
GBP	14100	10.0%
AUD	11416	8.1%
CAD	9948	7.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
usd	84784	60.0%
eur	21002	14.9%
gbp	14100	10.0%
aud	11416	8.1%
cad	9948	7.0%

Most occurring characters

Value	Count	Frequency (%)
U	117202	27.7%
D	106148	25.0%
S	84784	20.0%
A	21364	5.0%
E	21002	5.0%
R	21002	5.0%
G	14100	3.3%
B	14100	3.3%
P	14100	3.3%
C	9948	2.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	423750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
U	117202	27.7%
D	106148	25.0%
S	84784	20.0%
A	21364	5.0%
E	21002	5.0%
R	21002	5.0%
G	14100	3.3%
B	14100	3.3%
P	14100	3.3%
C	9948	2.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	423750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
U	117202	27.7%
D	106148	25.0%
S	84784	20.0%
A	21364	5.0%
E	21002	5.0%
R	21002	5.0%
G	14100	3.3%
B	14100	3.3%
P	14100	3.3%
C	9948	2.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	423750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
U	117202	27.7%
D	106148	25.0%
S	84784	20.0%
A	21364	5.0%
E	21002	5.0%
R	21002	5.0%
G	14100	3.3%
B	14100	3.3%
P	14100	3.3%
C	9948	2.3%

BS_Customer_Number
Text

Distinct	45195
Distinct (%)	32.0%
Missing	0
Missing (%)	0.0%
Memory size	7.8 MiB

Length

Max length	9
Median length	9
Mean length	8.8150584
Min length	8

Characters and Unicode

Total characters	1245127
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8795 ?
Unique (%)	6.2%

Sample

1st row	CUST15159
2nd row	CUST20779
3rd row	CUST28404
4th row	CUST7007
5th row	CUST39746

Value	Count	Frequency (%)
cust30007	16	< 0.1%
cust20916	15	< 0.1%
cust49463	15	< 0.1%
cust1260	15	< 0.1%
cust22216	13	< 0.1%
cust9060	13	< 0.1%
cust16580	13	< 0.1%
cust44259	13	< 0.1%
cust8676	13	< 0.1%
cust8906	13	< 0.1%
Other values (45185)	141111	99.9%

Most occurring characters

Value	Count	Frequency (%)
C	141250	11.3%
U	141250	11.3%
S	141250	11.3%
T	141250	11.3%
4	86333	6.9%
3	85701	6.9%
1	85340	6.9%
2	85096	6.8%
8	57083	4.6%
9	56870	4.6%
Other values (4)	223704	18.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1245127	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	141250	11.3%
U	141250	11.3%
S	141250	11.3%
T	141250	11.3%
4	86333	6.9%
3	85701	6.9%
1	85340	6.9%
2	85096	6.8%
8	57083	4.6%
9	56870	4.6%
Other values (4)	223704	18.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1245127	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	141250	11.3%
U	141250	11.3%
S	141250	11.3%
T	141250	11.3%
4	86333	6.9%
3	85701	6.9%
1	85340	6.9%
2	85096	6.8%
8	57083	4.6%
9	56870	4.6%
Other values (4)	223704	18.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1245127	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	141250	11.3%
U	141250	11.3%
S	141250	11.3%
T	141250	11.3%
4	86333	6.9%
3	85701	6.9%
1	85340	6.9%
2	85096	6.8%
8	57083	4.6%
9	56870	4.6%
Other values (4)	223704	18.0%

BS_Amount
Real number (ℝ)

High correlation

Distinct	122801
Distinct (%)	86.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1979.2208

Minimum	-4999.85
Maximum	4999.87
Zeros	0
Zeros (%)	0.0%
Negative	15000
Negative (%)	10.6%
Memory size	1.1 MiB

Quantile statistics

Minimum	-4999.85
5-th percentile	-2655.288
Q1	828.465
median	2221.17
Q3	3607.4425
95-th percentile	4724.491
Maximum	4999.87
Range	9999.72
Interquartile range (IQR)	2778.9775

Descriptive statistics

Standard deviation	2112.685
Coefficient of variation (CV)	1.0674327
Kurtosis	1.0466637
Mean	1979.2208
Median Absolute Deviation (MAD)	1389.74
Skewness	-1.0062879
Sum	2.7956493 × 10⁸
Variance	4463437.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4756.12	5	< 0.1%
953.97	5	< 0.1%
931.3	5	< 0.1%
3543.24	5	< 0.1%
4146.9	5	< 0.1%
1020.37	5	< 0.1%
1902	5	< 0.1%
2595.9	5	< 0.1%
1121	4	< 0.1%
4540.24	4	< 0.1%
Other values (122791)	141202	> 99.9%

Value	Count	Frequency (%)
-4999.85	1	< 0.1%
-4999.06	1	< 0.1%
-4998.84	2	< 0.1%
-4998.76	1	< 0.1%
-4998.23	1	< 0.1%
-4996.55	2	< 0.1%
-4996.24	1	< 0.1%
-4996.23	2	< 0.1%
-4996.21	2	< 0.1%
-4995.93	1	< 0.1%

Value	Count	Frequency (%)
4999.87	1	< 0.1%
4999.85	2	< 0.1%
4999.66	1	< 0.1%
4999.61	1	< 0.1%
4999.54	1	< 0.1%
4999.44	1	< 0.1%
4999.28	2	< 0.1%
4999.27	1	< 0.1%
4999.26	1	< 0.1%
4999.24	1	< 0.1%

BS_Payment_Method_Type
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.5 MiB

Credit Card	47296
PayPal	47110
ACH	46844

Length

Max length	11
Median length	6
Mean length	6.6792779
Min length	3

Characters and Unicode

Total characters	943448
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PayPal
2nd row	ACH
3rd row	ACH
4th row	Credit Card
5th row	PayPal

Common Values

Value	Count	Frequency (%)
Credit Card	47296	33.5%
PayPal	47110	33.4%
ACH	46844	33.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
credit	47296	25.1%
card	47296	25.1%
paypal	47110	25.0%
ach	46844	24.8%

Most occurring characters

Value	Count	Frequency (%)
a	141516	15.0%
C	141436	15.0%
r	94592	10.0%
d	94592	10.0%
P	94220	10.0%
e	47296	5.0%
i	47296	5.0%
t	47296	5.0%
	47296	5.0%
y	47110	5.0%
Other values (3)	140798	14.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	943448	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	141516	15.0%
C	141436	15.0%
r	94592	10.0%
d	94592	10.0%
P	94220	10.0%
e	47296	5.0%
i	47296	5.0%
t	47296	5.0%
	47296	5.0%
y	47110	5.0%
Other values (3)	140798	14.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	943448	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	141516	15.0%
C	141436	15.0%
r	94592	10.0%
d	94592	10.0%
P	94220	10.0%
e	47296	5.0%
i	47296	5.0%
t	47296	5.0%
	47296	5.0%
y	47110	5.0%
Other values (3)	140798	14.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	943448	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	141516	15.0%
C	141436	15.0%
r	94592	10.0%
d	94592	10.0%
P	94220	10.0%
e	47296	5.0%
i	47296	5.0%
t	47296	5.0%
	47296	5.0%
y	47110	5.0%
Other values (3)	140798	14.9%

BS_Card_Type
Categorical

High correlation

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.3 MiB

PayPal	47110
ACH	46844
Mastercard	15960
Visa	15697
Amex	15639

Length

Max length	10
Median length	6
Mean length	5.0133522
Min length	3

Characters and Unicode

Total characters	708136
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PayPal
2nd row	ACH
3rd row	ACH
4th row	Visa
5th row	PayPal

Common Values

Value	Count	Frequency (%)
PayPal	47110	33.4%
ACH	46844	33.2%
Mastercard	15960	11.3%
Visa	15697	11.1%
Amex	15639	11.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
paypal	47110	33.4%
ach	46844	33.2%
mastercard	15960	11.3%
visa	15697	11.1%
amex	15639	11.1%

Most occurring characters

Value	Count	Frequency (%)
a	141837	20.0%
P	94220	13.3%
A	62483	8.8%
y	47110	6.7%
l	47110	6.7%
C	46844	6.6%
H	46844	6.6%
r	31920	4.5%
s	31657	4.5%
e	31599	4.5%
Other values (8)	126512	17.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	708136	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	141837	20.0%
P	94220	13.3%
A	62483	8.8%
y	47110	6.7%
l	47110	6.7%
C	46844	6.6%
H	46844	6.6%
r	31920	4.5%
s	31657	4.5%
e	31599	4.5%
Other values (8)	126512	17.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	708136	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	141837	20.0%
P	94220	13.3%
A	62483	8.8%
y	47110	6.7%
l	47110	6.7%
C	46844	6.6%
H	46844	6.6%
r	31920	4.5%
s	31657	4.5%
e	31599	4.5%
Other values (8)	126512	17.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	708136	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	141837	20.0%
P	94220	13.3%
A	62483	8.8%
y	47110	6.7%
l	47110	6.7%
C	46844	6.6%
H	46844	6.6%
r	31920	4.5%
s	31657	4.5%
e	31599	4.5%
Other values (8)	126512	17.9%

BS_Processor_Transaction_Id
Text

Distinct	124907
Distinct (%)	88.4%
Missing	0
Missing (%)	0.0%
Memory size	8.4 MiB

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	1836250
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	112330 ?
Unique (%)	79.5%

Sample

1st row	PROC-21233551
2nd row	PROC-45142454
3rd row	PROC-76309118
4th row	PROC-62839998
5th row	PROC-62414033

Value	Count	Frequency (%)
proc-54910620	4	< 0.1%
proc-99885580	4	< 0.1%
proc-82847137	4	< 0.1%
proc-34872954	4	< 0.1%
proc-52280805	4	< 0.1%
proc-33425997	4	< 0.1%
proc-81472295	4	< 0.1%
proc-28936129	4	< 0.1%
proc-30105287	4	< 0.1%
proc-19700926	4	< 0.1%
Other values (124897)	141210	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
P	141250	7.7%
R	141250	7.7%
O	141250	7.7%
C	141250	7.7%
-	141250	7.7%
7	115128	6.3%
8	115060	6.3%
1	114741	6.2%
4	114512	6.2%
3	114444	6.2%
Other values (5)	556115	30.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1836250	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
P	141250	7.7%
R	141250	7.7%
O	141250	7.7%
C	141250	7.7%
-	141250	7.7%
7	115128	6.3%
8	115060	6.3%
1	114741	6.2%
4	114512	6.2%
3	114444	6.2%
Other values (5)	556115	30.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1836250	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
P	141250	7.7%
R	141250	7.7%
O	141250	7.7%
C	141250	7.7%
-	141250	7.7%
7	115128	6.3%
8	115060	6.3%
1	114741	6.2%
4	114512	6.2%
3	114444	6.2%
Other values (5)	556115	30.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1836250	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
P	141250	7.7%
R	141250	7.7%
O	141250	7.7%
C	141250	7.7%
-	141250	7.7%
7	115128	6.3%
8	115060	6.3%
1	114741	6.2%
4	114512	6.2%
3	114444	6.2%
Other values (5)	556115	30.3%

BS_Payment_Gateway
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.8 MiB

Cybersource	47296
PayPal	47110
GoCardless	46844

Length

Max length	11
Median length	10
Mean length	9.0007504
Min length	6

Characters and Unicode

Total characters	1271356
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PayPal
2nd row	GoCardless
3rd row	GoCardless
4th row	Cybersource
5th row	PayPal

Common Values

Value	Count	Frequency (%)
Cybersource	47296	33.5%
PayPal	47110	33.4%
GoCardless	46844	33.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
cybersource	47296	33.5%
paypal	47110	33.4%
gocardless	46844	33.2%

Most occurring characters

Value	Count	Frequency (%)
e	141436	11.1%
r	141436	11.1%
a	141064	11.1%
s	140984	11.1%
y	94406	7.4%
P	94220	7.4%
C	94140	7.4%
o	94140	7.4%
l	93954	7.4%
b	47296	3.7%
Other values (4)	188280	14.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1271356	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	141436	11.1%
r	141436	11.1%
a	141064	11.1%
s	140984	11.1%
y	94406	7.4%
P	94220	7.4%
C	94140	7.4%
o	94140	7.4%
l	93954	7.4%
b	47296	3.7%
Other values (4)	188280	14.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1271356	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	141436	11.1%
r	141436	11.1%
a	141064	11.1%
s	140984	11.1%
y	94406	7.4%
P	94220	7.4%
C	94140	7.4%
o	94140	7.4%
l	93954	7.4%
b	47296	3.7%
Other values (4)	188280	14.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1271356	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	141436	11.1%
r	141436	11.1%
a	141064	11.1%
s	140984	11.1%
y	94406	7.4%
P	94220	7.4%
C	94140	7.4%
o	94140	7.4%
l	93954	7.4%
b	47296	3.7%
Other values (4)	188280	14.8%

BS_Processor_Response_Code
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	5.5 MiB

BS_Processor_Response_Message
Categorical

High correlation Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.8 MiB

Approved	125000
Refund Processed	12500
Chargeback Initiated	2500
Chargeback Reversed	1250

Length

Max length	20
Median length	8
Mean length	9.0176991
Min length	8

Characters and Unicode

Total characters	1273750
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Approved
2nd row	Approved
3rd row	Approved
4th row	Approved
5th row	Approved

Common Values

Value	Count	Frequency (%)
Approved	125000	88.5%
Refund Processed	12500	8.8%
Chargeback Initiated	2500	1.8%
Chargeback Reversed	1250	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
approved	125000	79.4%
refund	12500	7.9%
processed	12500	7.9%
chargeback	3750	2.4%
initiated	2500	1.6%
reversed	1250	0.8%

Most occurring characters

Value	Count	Frequency (%)
p	250000	19.6%
e	172500	13.5%
d	153750	12.1%
r	142500	11.2%
o	137500	10.8%
v	126250	9.9%
A	125000	9.8%
s	26250	2.1%
c	16250	1.3%
	16250	1.3%
Other values (14)	107500	8.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1273750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
p	250000	19.6%
e	172500	13.5%
d	153750	12.1%
r	142500	11.2%
o	137500	10.8%
v	126250	9.9%
A	125000	9.8%
s	26250	2.1%
c	16250	1.3%
	16250	1.3%
Other values (14)	107500	8.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1273750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
p	250000	19.6%
e	172500	13.5%
d	153750	12.1%
r	142500	11.2%
o	137500	10.8%
v	126250	9.9%
A	125000	9.8%
s	26250	2.1%
c	16250	1.3%
	16250	1.3%
Other values (14)	107500	8.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1273750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
p	250000	19.6%
e	172500	13.5%
d	153750	12.1%
r	142500	11.2%
o	137500	10.8%
v	126250	9.9%
A	125000	9.8%
s	26250	2.1%
c	16250	1.3%
	16250	1.3%
Other values (14)	107500	8.4%

BS_Inv_Payment_Number
Text

Distinct	125000
Distinct (%)	88.5%
Missing	0
Missing (%)	0.0%
Memory size	8.1 MiB

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	1553750
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	112500 ?
Unique (%)	79.6%

Sample

1st row	PAY-0000000
2nd row	PAY-0000001
3rd row	PAY-0000002
4th row	PAY-0000003
5th row	PAY-0000004

Value	Count	Frequency (%)
pay-0038489	4	< 0.1%
pay-0033214	4	< 0.1%
pay-0066396	4	< 0.1%
pay-0063049	4	< 0.1%
pay-0124481	4	< 0.1%
pay-0064521	4	< 0.1%
pay-0113868	4	< 0.1%
pay-0030656	4	< 0.1%
pay-0032004	4	< 0.1%
pay-0063738	4	< 0.1%
Other values (124990)	141210	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
0	334091	21.5%
P	141250	9.1%
A	141250	9.1%
Y	141250	9.1%
-	141250	9.1%
1	107672	6.9%
2	73838	4.8%
4	68511	4.4%
3	68239	4.4%
5	67331	4.3%
Other values (4)	269068	17.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1553750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	334091	21.5%
P	141250	9.1%
A	141250	9.1%
Y	141250	9.1%
-	141250	9.1%
1	107672	6.9%
2	73838	4.8%
4	68511	4.4%
3	68239	4.4%
5	67331	4.3%
Other values (4)	269068	17.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1553750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	334091	21.5%
P	141250	9.1%
A	141250	9.1%
Y	141250	9.1%
-	141250	9.1%
1	107672	6.9%
2	73838	4.8%
4	68511	4.4%
3	68239	4.4%
5	67331	4.3%
Other values (4)	269068	17.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1553750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	334091	21.5%
P	141250	9.1%
A	141250	9.1%
Y	141250	9.1%
-	141250	9.1%
1	107672	6.9%
2	73838	4.8%
4	68511	4.4%
3	68239	4.4%
5	67331	4.3%
Other values (4)	269068	17.3%

BS_Sales_Channel
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.5 MiB

In-Store	47295
Online	47147
Phone	46808

Length

Max length	8
Median length	6
Mean length	6.3382796
Min length	5

Characters and Unicode

Total characters	895282
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	In-Store
2nd row	In-Store
3rd row	Phone
4th row	Phone
5th row	In-Store

Common Values

Value	Count	Frequency (%)
In-Store	47295	33.5%
Online	47147	33.4%
Phone	46808	33.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
in-store	47295	33.5%
online	47147	33.4%
phone	46808	33.1%

Most occurring characters

Value	Count	Frequency (%)
n	188397	21.0%
e	141250	15.8%
o	94103	10.5%
I	47295	5.3%
-	47295	5.3%
S	47295	5.3%
t	47295	5.3%
r	47295	5.3%
O	47147	5.3%
l	47147	5.3%
Other values (3)	140763	15.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	895282	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	188397	21.0%
e	141250	15.8%
o	94103	10.5%
I	47295	5.3%
-	47295	5.3%
S	47295	5.3%
t	47295	5.3%
r	47295	5.3%
O	47147	5.3%
l	47147	5.3%
Other values (3)	140763	15.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	895282	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	188397	21.0%
e	141250	15.8%
o	94103	10.5%
I	47295	5.3%
-	47295	5.3%
S	47295	5.3%
t	47295	5.3%
r	47295	5.3%
O	47147	5.3%
l	47147	5.3%
Other values (3)	140763	15.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	895282	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	188397	21.0%
e	141250	15.8%
o	94103	10.5%
I	47295	5.3%
-	47295	5.3%
S	47295	5.3%
t	47295	5.3%
r	47295	5.3%
O	47147	5.3%
l	47147	5.3%
Other values (3)	140763	15.7%

BS_Foreign_Exchange_Rate
Real number (ℝ)

High correlation

Distinct	953
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.99235357

Minimum	0.6534
Maximum	1.2827
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0.6534
5-th percentile	0.6614
Q1	0.9933
median	1.0016
Q3	1.01
95-th percentile	1.2702
Maximum	1.2827
Range	0.6293
Interquartile range (IQR)	0.0167

Descriptive statistics

Standard deviation	0.15062953
Coefficient of variation (CV)	0.15179019
Kurtosis	0.74384548
Mean	0.99235357
Median Absolute Deviation (MAD)	0.0083
Skewness	-0.5844689
Sum	140169.94
Variance	0.022689257
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.0012	481	0.3%
0.9918	478	0.3%
0.9925	476	0.3%
0.997	472	0.3%
0.9978	468	0.3%
0.9963	465	0.3%
0.9905	465	0.3%
0.9928	463	0.3%
1.0054	462	0.3%
1.0005	462	0.3%
Other values (943)	136558	96.7%

Value	Count	Frequency (%)
0.6534	49	< 0.1%
0.6535	91	0.1%
0.6536	86	0.1%
0.6537	87	0.1%
0.6538	85	0.1%
0.6539	105	0.1%
0.654	83	0.1%
0.6541	105	0.1%
0.6542	96	0.1%
0.6543	73	0.1%

Value	Count	Frequency (%)
1.2827	34	< 0.1%
1.2826	58	< 0.1%
1.2825	66	< 0.1%
1.2824	44	< 0.1%
1.2823	46	< 0.1%
1.2822	33	< 0.1%
1.2821	42	< 0.1%
1.282	52	< 0.1%
1.2819	61	< 0.1%
1.2818	56	< 0.1%

GW_Transaction_ID
Text

Missing

Distinct	124128
Distinct (%)	98.3%
Missing	15000
Missing (%)	10.6%
Memory size	8.0 MiB

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Characters and Unicode

Total characters	1767500
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	122024 ?
Unique (%)	96.7%

Sample

1st row	GW-TRX-9972261
2nd row	GW-TRX-8455695
3rd row	GW-TRX-5184318
4th row	GW-TRX-8104962
5th row	GW-TRX-2770667

Value	Count	Frequency (%)
gw-trx-8805233	4	< 0.1%
gw-trx-4653021	3	< 0.1%
gw-trx-1392363	3	< 0.1%
gw-trx-4044666	3	< 0.1%
gw-trx-4979170	3	< 0.1%
gw-trx-5701527	3	< 0.1%
gw-trx-4420744	3	< 0.1%
gw-trx-3932125	3	< 0.1%
gw-trx-5469733	3	< 0.1%
gw-trx-3951989	3	< 0.1%
Other values (124118)	126219	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
-	252500	14.3%
G	126250	7.1%
W	126250	7.1%
T	126250	7.1%
R	126250	7.1%
X	126250	7.1%
2	90204	5.1%
3	89943	5.1%
4	89913	5.1%
6	89744	5.1%
Other values (6)	523946	29.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1767500	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	252500	14.3%
G	126250	7.1%
W	126250	7.1%
T	126250	7.1%
R	126250	7.1%
X	126250	7.1%
2	90204	5.1%
3	89943	5.1%
4	89913	5.1%
6	89744	5.1%
Other values (6)	523946	29.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1767500	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	252500	14.3%
G	126250	7.1%
W	126250	7.1%
T	126250	7.1%
R	126250	7.1%
X	126250	7.1%
2	90204	5.1%
3	89943	5.1%
4	89913	5.1%
6	89744	5.1%
Other values (6)	523946	29.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1767500	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	252500	14.3%
G	126250	7.1%
W	126250	7.1%
T	126250	7.1%
R	126250	7.1%
X	126250	7.1%
2	90204	5.1%
3	89943	5.1%
4	89913	5.1%
6	89744	5.1%
Other values (6)	523946	29.6%

GW_name
Categorical

High correlation Missing

Distinct	3
Distinct (%)	< 0.1%
Missing	15000
Missing (%)	10.6%
Memory size	7.8 MiB

Cybersource	42213
PayPal	42124
GoCardless	41913

Length

Max length	11
Median length	10
Mean length	8.9997386
Min length	6

Characters and Unicode

Total characters	1136217
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PayPal
2nd row	GoCardless
3rd row	GoCardless
4th row	Cybersource
5th row	PayPal

Common Values

Value	Count	Frequency (%)
Cybersource	42213	29.9%
PayPal	42124	29.8%
GoCardless	41913	29.7%
(Missing)	15000	10.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
cybersource	42213	33.4%
paypal	42124	33.4%
gocardless	41913	33.2%

Most occurring characters

Value	Count	Frequency (%)
e	126339	11.1%
r	126339	11.1%
a	126161	11.1%
s	126039	11.1%
y	84337	7.4%
P	84248	7.4%
C	84126	7.4%
o	84126	7.4%
l	84037	7.4%
b	42213	3.7%
Other values (4)	168252	14.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1136217	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	126339	11.1%
r	126339	11.1%
a	126161	11.1%
s	126039	11.1%
y	84337	7.4%
P	84248	7.4%
C	84126	7.4%
o	84126	7.4%
l	84037	7.4%
b	42213	3.7%
Other values (4)	168252	14.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1136217	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	126339	11.1%
r	126339	11.1%
a	126161	11.1%
s	126039	11.1%
y	84337	7.4%
P	84248	7.4%
C	84126	7.4%
o	84126	7.4%
l	84037	7.4%
b	42213	3.7%
Other values (4)	168252	14.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1136217	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	126339	11.1%
r	126339	11.1%
a	126161	11.1%
s	126039	11.1%
y	84337	7.4%
P	84248	7.4%
C	84126	7.4%
o	84126	7.4%
l	84037	7.4%
b	42213	3.7%
Other values (4)	168252	14.8%

GW_Transaction_Status
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	15000
Missing (%)	10.6%
Memory size	7.5 MiB

settled	126250

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	883750
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	settled
2nd row	settled
3rd row	settled
4th row	settled
5th row	settled

Common Values

Value	Count	Frequency (%)
settled	126250	89.4%
(Missing)	15000	10.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
settled	126250	100.0%

Most occurring characters

Value	Count	Frequency (%)
e	252500	28.6%
t	252500	28.6%
s	126250	14.3%
l	126250	14.3%
d	126250	14.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	883750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	252500	28.6%
t	252500	28.6%
s	126250	14.3%
l	126250	14.3%
d	126250	14.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	883750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	252500	28.6%
t	252500	28.6%
s	126250	14.3%
l	126250	14.3%
d	126250	14.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	883750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	252500	28.6%
t	252500	28.6%
s	126250	14.3%
l	126250	14.3%
d	126250	14.3%

GW_Response_Code
Unsupported

Missing Rejected Unsupported

Missing	15000
Missing (%)	10.6%
Memory size	5.2 MiB

GW_Response
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	15000
Missing (%)	10.6%
Memory size	7.7 MiB

Approved	126250

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	1010000
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Approved
2nd row	Approved
3rd row	Approved
4th row	Approved
5th row	Approved

Common Values

Value	Count	Frequency (%)
Approved	126250	89.4%
(Missing)	15000	10.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
approved	126250	100.0%

Most occurring characters

Value	Count	Frequency (%)
p	252500	25.0%
A	126250	12.5%
r	126250	12.5%
o	126250	12.5%
v	126250	12.5%
e	126250	12.5%
d	126250	12.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1010000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
p	252500	25.0%
A	126250	12.5%
r	126250	12.5%
o	126250	12.5%
v	126250	12.5%
e	126250	12.5%
d	126250	12.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1010000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
p	252500	25.0%
A	126250	12.5%
r	126250	12.5%
o	126250	12.5%
v	126250	12.5%
e	126250	12.5%
d	126250	12.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1010000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
p	252500	25.0%
A	126250	12.5%
r	126250	12.5%
o	126250	12.5%
v	126250	12.5%
e	126250	12.5%
d	126250	12.5%

GW_Transaction_Amount
Real number (ℝ)

High correlation Missing

Distinct	110454
Distinct (%)	87.5%
Missing	15000
Missing (%)	10.6%
Infinite	0
Infinite (%)	0.0%
Mean	2513.3731

Minimum	25.08
Maximum	4999.87
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	25.08
5-th percentile	270.357
Q1	1269.245
median	2512.08
Q3	3756.1275
95-th percentile	4751.42
Maximum	4999.87
Range	4974.79
Interquartile range (IQR)	2486.8825

Descriptive statistics

Standard deviation	1436.5054
Coefficient of variation (CV)	0.57154485
Kurtosis	-1.1975413
Mean	2513.3731
Median Absolute Deviation (MAD)	1243.5
Skewness	0.00018353774
Sum	3.1731335 × 10⁸
Variance	2063547.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3543.24	5	< 0.1%
4756.12	5	< 0.1%
1902	5	< 0.1%
4146.9	5	< 0.1%
2595.9	5	< 0.1%
931.3	5	< 0.1%
1020.37	5	< 0.1%
953.97	5	< 0.1%
4610.19	4	< 0.1%
659.95	4	< 0.1%
Other values (110444)	126202	89.3%
(Missing)	15000	10.6%

Value	Count	Frequency (%)
25.08	1	< 0.1%
25.15	1	< 0.1%
25.16	1	< 0.1%
25.31	1	< 0.1%
25.32	1	< 0.1%
25.34	1	< 0.1%
25.37	2	< 0.1%
25.4	1	< 0.1%
25.47	1	< 0.1%
25.48	1	< 0.1%

Value	Count	Frequency (%)
4999.87	1	< 0.1%
4999.85	2	< 0.1%
4999.66	1	< 0.1%
4999.61	1	< 0.1%
4999.54	1	< 0.1%
4999.44	1	< 0.1%
4999.28	2	< 0.1%
4999.27	1	< 0.1%
4999.26	1	< 0.1%
4999.24	1	< 0.1%

GW_Trx_Currency
Categorical

High correlation Missing

Distinct	5
Distinct (%)	< 0.1%
Missing	15000
Missing (%)	10.6%
Memory size	7.1 MiB

USD	75838
EUR	18783
GBP	12585
AUD	10152
CAD	8892

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	378750
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	USD
2nd row	USD
3rd row	USD
4th row	GBP
5th row	USD

Common Values

Value	Count	Frequency (%)
USD	75838	53.7%
EUR	18783	13.3%
GBP	12585	8.9%
AUD	10152	7.2%
CAD	8892	6.3%
(Missing)	15000	10.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
usd	75838	60.1%
eur	18783	14.9%
gbp	12585	10.0%
aud	10152	8.0%
cad	8892	7.0%

Most occurring characters

Value	Count	Frequency (%)
U	104773	27.7%
D	94882	25.1%
S	75838	20.0%
A	19044	5.0%
E	18783	5.0%
R	18783	5.0%
G	12585	3.3%
B	12585	3.3%
P	12585	3.3%
C	8892	2.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	378750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
U	104773	27.7%
D	94882	25.1%
S	75838	20.0%
A	19044	5.0%
E	18783	5.0%
R	18783	5.0%
G	12585	3.3%
B	12585	3.3%
P	12585	3.3%
C	8892	2.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	378750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
U	104773	27.7%
D	94882	25.1%
S	75838	20.0%
A	19044	5.0%
E	18783	5.0%
R	18783	5.0%
G	12585	3.3%
B	12585	3.3%
P	12585	3.3%
C	8892	2.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	378750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
U	104773	27.7%
D	94882	25.1%
S	75838	20.0%
A	19044	5.0%
E	18783	5.0%
R	18783	5.0%
G	12585	3.3%
B	12585	3.3%
P	12585	3.3%
C	8892	2.3%

GW_Trx_Type
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	15000
Missing (%)	10.6%
Memory size	7.5 MiB

payment	126250

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	883750
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	payment
2nd row	payment
3rd row	payment
4th row	payment
5th row	payment

Common Values

Value	Count	Frequency (%)
payment	126250	89.4%
(Missing)	15000	10.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
payment	126250	100.0%

Most occurring characters

Value	Count	Frequency (%)
p	126250	14.3%
a	126250	14.3%
y	126250	14.3%
m	126250	14.3%
e	126250	14.3%
n	126250	14.3%
t	126250	14.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	883750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
p	126250	14.3%
a	126250	14.3%
y	126250	14.3%
m	126250	14.3%
e	126250	14.3%
n	126250	14.3%
t	126250	14.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	883750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
p	126250	14.3%
a	126250	14.3%
y	126250	14.3%
m	126250	14.3%
e	126250	14.3%
n	126250	14.3%
t	126250	14.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	883750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
p	126250	14.3%
a	126250	14.3%
y	126250	14.3%
m	126250	14.3%
e	126250	14.3%
n	126250	14.3%
t	126250	14.3%

GW_Card_Brand
Categorical

High correlation Missing

Distinct	5
Distinct (%)	< 0.1%
Missing	15000
Missing (%)	10.6%
Memory size	7.6 MiB

PayPal	42124
GoCardless	41913
Mastercard	14223
Visa	13996
Amex	13994

Length

Max length	10
Median length	6
Mean length	7.3351604
Min length	4

Characters and Unicode

Total characters	926064
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PayPal
2nd row	GoCardless
3rd row	GoCardless
4th row	Visa
5th row	PayPal

Common Values

Value	Count	Frequency (%)
PayPal	42124	29.8%
GoCardless	41913	29.7%
Mastercard	14223	10.1%
Visa	13996	9.9%
Amex	13994	9.9%
(Missing)	15000	10.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
paypal	42124	33.4%
gocardless	41913	33.2%
mastercard	14223	11.3%
visa	13996	11.1%
amex	13994	11.1%

Most occurring characters

Value	Count	Frequency (%)
a	168603	18.2%
s	112045	12.1%
P	84248	9.1%
l	84037	9.1%
r	70359	7.6%
e	70130	7.6%
d	56136	6.1%
y	42124	4.5%
C	41913	4.5%
o	41913	4.5%
Other values (9)	154556	16.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	926064	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	168603	18.2%
s	112045	12.1%
P	84248	9.1%
l	84037	9.1%
r	70359	7.6%
e	70130	7.6%
d	56136	6.1%
y	42124	4.5%
C	41913	4.5%
o	41913	4.5%
Other values (9)	154556	16.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	926064	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	168603	18.2%
s	112045	12.1%
P	84248	9.1%
l	84037	9.1%
r	70359	7.6%
e	70130	7.6%
d	56136	6.1%
y	42124	4.5%
C	41913	4.5%
o	41913	4.5%
Other values (9)	154556	16.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	926064	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	168603	18.2%
s	112045	12.1%
P	84248	9.1%
l	84037	9.1%
r	70359	7.6%
e	70130	7.6%
d	56136	6.1%
y	42124	4.5%
C	41913	4.5%
o	41913	4.5%
Other values (9)	154556	16.7%

GW_fees
Real number (ℝ)

High correlation Missing

Distinct	4995
Distinct (%)	4.0%
Missing	15000
Missing (%)	10.6%
Infinite	0
Infinite (%)	0.0%
Mean	16.786014

Minimum	0.06
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0.06
5-th percentile	1.3
Q1	6.03
median	11.95
Q3	26.93
95-th percentile	42.59
Maximum	50
Range	49.94
Interquartile range (IQR)	20.9

Descriptive statistics

Standard deviation	13.169925
Coefficient of variation (CV)	0.78457725
Kurtosis	-0.59754096
Mean	16.786014
Median Absolute Deviation (MAD)	8.39
Skewness	0.72097683
Sum	2119234.3
Variance	173.44692
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.94	77	0.1%
0.73	76	0.1%
3.19	75	0.1%
10.64	75	0.1%
5.52	75	0.1%
7.95	74	0.1%
5.82	74	0.1%
7.99	73	0.1%
4.84	72	0.1%
2.21	72	0.1%
Other values (4985)	125507	88.9%
(Missing)	15000	10.6%

Value	Count	Frequency (%)
0.06	12	< 0.1%
0.07	34	< 0.1%
0.08	41	< 0.1%
0.09	26	< 0.1%
0.1	37	< 0.1%
0.11	38	< 0.1%
0.12	39	< 0.1%
0.13	33	< 0.1%
0.14	29	< 0.1%
0.15	40	< 0.1%

Value	Count	Frequency (%)
50	2	< 0.1%
49.99	6	< 0.1%
49.98	6	< 0.1%
49.97	4	< 0.1%
49.96	12	< 0.1%
49.95	11	< 0.1%
49.94	8	< 0.1%
49.93	12	< 0.1%
49.92	6	< 0.1%
49.91	6	< 0.1%

GW_Net_Settled_Amt
Real number (ℝ)

High correlation Missing

Distinct	112419
Distinct (%)	89.0%
Missing	15000
Missing (%)	10.6%
Infinite	0
Infinite (%)	0.0%
Mean	2496.5871

Minimum	24.89
Maximum	4987.37
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	24.89
5-th percentile	268.358
Q1	1260.2175
median	2495.195
Q3	3731.845
95-th percentile	4721.22
Maximum	4987.37
Range	4962.48
Interquartile range (IQR)	2471.6275

Descriptive statistics

Standard deviation	1426.9339
Coefficient of variation (CV)	0.57155383
Kurtosis	-1.1973898
Mean	2496.5871
Median Absolute Deviation (MAD)	1235.585
Skewness	0.00028834919
Sum	3.1519412 × 10⁸
Variance	2036140.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2897.74	5	< 0.1%
3385.57	5	< 0.1%
3300.21	5	< 0.1%
4796.47	5	< 0.1%
3598.04	4	< 0.1%
4285.42	4	< 0.1%
1161.27	4	< 0.1%
1456.09	4	< 0.1%
2408.8	4	< 0.1%
3891.57	4	< 0.1%
Other values (112409)	126206	89.3%
(Missing)	15000	10.6%

Value	Count	Frequency (%)
24.89	1	< 0.1%
24.96	1	< 0.1%
25.1	1	< 0.1%
25.12	1	< 0.1%
25.22	1	< 0.1%
25.23	1	< 0.1%
25.26	1	< 0.1%
25.28	1	< 0.1%
25.31	2	< 0.1%
25.34	1	< 0.1%

Value	Count	Frequency (%)
4987.37	1	< 0.1%
4987.35	1	< 0.1%
4987.11	1	< 0.1%
4987.04	1	< 0.1%
4986.94	1	< 0.1%
4986.78	2	< 0.1%
4986.68	1	< 0.1%
4986.35	1	< 0.1%
4986.34	1	< 0.1%
4986.23	1	< 0.1%

GW_Trx_Date
Date

Missing

Distinct	90
Distinct (%)	0.1%
Missing	15000
Missing (%)	10.6%
Memory size	1.1 MiB

Minimum	2025-01-01 00:00:00
Maximum	2025-03-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

GW_Ref_Number
Text

Missing

Distinct	125000
Distinct (%)	99.0%
Missing	15000
Missing (%)	10.6%
Memory size	7.7 MiB

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	1388750
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	123750 ?
Unique (%)	98.0%

Sample

1st row	PAY-0000000
2nd row	PAY-0000001
3rd row	PAY-0000002
4th row	PAY-0000003
5th row	PAY-0000004

Value	Count	Frequency (%)
pay-0118884	2	< 0.1%
pay-0110496	2	< 0.1%
pay-0015196	2	< 0.1%
pay-0046112	2	< 0.1%
pay-0046204	2	< 0.1%
pay-0110180	2	< 0.1%
pay-0077288	2	< 0.1%
pay-0077050	2	< 0.1%
pay-0079924	2	< 0.1%
pay-0048439	2	< 0.1%
Other values (124990)	126230	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
0	298496	21.5%
P	126250	9.1%
A	126250	9.1%
Y	126250	9.1%
-	126250	9.1%
1	96397	6.9%
2	66100	4.8%
4	61140	4.4%
3	61114	4.4%
8	60139	4.3%
Other values (4)	240364	17.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1388750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	298496	21.5%
P	126250	9.1%
A	126250	9.1%
Y	126250	9.1%
-	126250	9.1%
1	96397	6.9%
2	66100	4.8%
4	61140	4.4%
3	61114	4.4%
8	60139	4.3%
Other values (4)	240364	17.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1388750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	298496	21.5%
P	126250	9.1%
A	126250	9.1%
Y	126250	9.1%
-	126250	9.1%
1	96397	6.9%
2	66100	4.8%
4	61140	4.4%
3	61114	4.4%
8	60139	4.3%
Other values (4)	240364	17.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1388750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	298496	21.5%
P	126250	9.1%
A	126250	9.1%
Y	126250	9.1%
-	126250	9.1%
1	96397	6.9%
2	66100	4.8%
4	61140	4.4%
3	61114	4.4%
8	60139	4.3%
Other values (4)	240364	17.3%

BS_GW_Match
Boolean

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	138.1 KiB

True	126250
False	15000

Value	Count	Frequency (%)
True	126250	89.4%
False	15000	10.6%

MP_Trx_ID
Text

Missing

Distinct	124946
Distinct (%)	> 99.9%
Missing	16250
Missing (%)	11.5%
Memory size	8.4 MiB

Length

Max length	17
Median length	17
Mean length	17
Min length	17

Characters and Unicode

Total characters	2125000
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	124892 ?
Unique (%)	99.9%

Sample

1st row	PROC-TRX-96148747
2nd row	PROC-TRX-53756634
3rd row	PROC-TRX-96643401
4th row	PROC-TRX-48503361
5th row	PROC-TRX-87613870

Value	Count	Frequency (%)
proc-trx-20751798	2	< 0.1%
proc-trx-47008295	2	< 0.1%
proc-trx-18122493	2	< 0.1%
proc-trx-77205797	2	< 0.1%
proc-trx-72429823	2	< 0.1%
proc-trx-59325275	2	< 0.1%
proc-trx-28064569	2	< 0.1%
proc-trx-77635747	2	< 0.1%
proc-trx-93071076	2	< 0.1%
proc-trx-76043245	2	< 0.1%
Other values (124936)	124980	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
-	250000	11.8%
R	250000	11.8%
P	125000	5.9%
O	125000	5.9%
C	125000	5.9%
T	125000	5.9%
X	125000	5.9%
4	101764	4.8%
8	101637	4.8%
2	101575	4.8%
Other values (7)	695024	32.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2125000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	250000	11.8%
R	250000	11.8%
P	125000	5.9%
O	125000	5.9%
C	125000	5.9%
T	125000	5.9%
X	125000	5.9%
4	101764	4.8%
8	101637	4.8%
2	101575	4.8%
Other values (7)	695024	32.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2125000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	250000	11.8%
R	250000	11.8%
P	125000	5.9%
O	125000	5.9%
C	125000	5.9%
T	125000	5.9%
X	125000	5.9%
4	101764	4.8%
8	101637	4.8%
2	101575	4.8%
Other values (7)	695024	32.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2125000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	250000	11.8%
R	250000	11.8%
P	125000	5.9%
O	125000	5.9%
C	125000	5.9%
T	125000	5.9%
X	125000	5.9%
4	101764	4.8%
8	101637	4.8%
2	101575	4.8%
Other values (7)	695024	32.7%

MP_Processor_Type
Categorical

High correlation Missing

Distinct	4
Distinct (%)	< 0.1%
Missing	16250
Missing (%)	11.5%
Memory size	7.7 MiB

PayPal	41715
GoCardless	41514
ClientLine	27924
Amex	13847

Length

Max length	10
Median length	10
Mean length	8.000464
Min length	4

Characters and Unicode

Total characters	1000058
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PayPal
2nd row	GoCardless
3rd row	GoCardless
4th row	ClientLine
5th row	PayPal

Common Values

Value	Count	Frequency (%)
PayPal	41715	29.5%
GoCardless	41514	29.4%
ClientLine	27924	19.8%
Amex	13847	9.8%
(Missing)	16250	11.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
paypal	41715	33.4%
gocardless	41514	33.2%
clientline	27924	22.3%
amex	13847	11.1%

Most occurring characters

Value	Count	Frequency (%)
a	124944	12.5%
e	111209	11.1%
l	111153	11.1%
P	83430	8.3%
s	83028	8.3%
C	69438	6.9%
i	55848	5.6%
n	55848	5.6%
y	41715	4.2%
G	41514	4.2%
Other values (8)	221931	22.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1000058	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	124944	12.5%
e	111209	11.1%
l	111153	11.1%
P	83430	8.3%
s	83028	8.3%
C	69438	6.9%
i	55848	5.6%
n	55848	5.6%
y	41715	4.2%
G	41514	4.2%
Other values (8)	221931	22.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1000058	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	124944	12.5%
e	111209	11.1%
l	111153	11.1%
P	83430	8.3%
s	83028	8.3%
C	69438	6.9%
i	55848	5.6%
n	55848	5.6%
y	41715	4.2%
G	41514	4.2%
Other values (8)	221931	22.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1000058	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	124944	12.5%
e	111209	11.1%
l	111153	11.1%
P	83430	8.3%
s	83028	8.3%
C	69438	6.9%
i	55848	5.6%
n	55848	5.6%
y	41715	4.2%
G	41514	4.2%
Other values (8)	221931	22.2%

MP_Trx_Type
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	16250
Missing (%)	11.5%
Memory size	7.5 MiB

payment	125000

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	875000
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	payment
2nd row	payment
3rd row	payment
4th row	payment
5th row	payment

Common Values

Value	Count	Frequency (%)
payment	125000	88.5%
(Missing)	16250	11.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
payment	125000	100.0%

Most occurring characters

Value	Count	Frequency (%)
p	125000	14.3%
a	125000	14.3%
y	125000	14.3%
m	125000	14.3%
e	125000	14.3%
n	125000	14.3%
t	125000	14.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	875000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
p	125000	14.3%
a	125000	14.3%
y	125000	14.3%
m	125000	14.3%
e	125000	14.3%
n	125000	14.3%
t	125000	14.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	875000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
p	125000	14.3%
a	125000	14.3%
y	125000	14.3%
m	125000	14.3%
e	125000	14.3%
n	125000	14.3%
t	125000	14.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	875000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
p	125000	14.3%
a	125000	14.3%
y	125000	14.3%
m	125000	14.3%
e	125000	14.3%
n	125000	14.3%
t	125000	14.3%

MP_Processor_Fee
Real number (ℝ)

High correlation Missing Zeros

Distinct	7087
Distinct (%)	5.7%
Missing	16250
Missing (%)	11.5%
Infinite	0
Infinite (%)	0.0%
Mean	9.7874818

Minimum	0
Maximum	74.99
Zeros	83229
Zeros (%)	58.9%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	14.34
95-th percentile	47.96
Maximum	74.99
Range	74.99
Interquartile range (IQR)	14.34

Descriptive statistics

Standard deviation	17.322844
Coefficient of variation (CV)	1.769898
Kurtosis	2.0055467
Mean	9.7874818
Median Absolute Deviation (MAD)	0
Skewness	1.7338711
Sum	1223435.2
Variance	300.08092
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	83229	58.9%
28.66	18	< 0.1%
17.38	18	< 0.1%
20.4	18	< 0.1%
12.85	18	< 0.1%
49.61	18	< 0.1%
22.71	17	< 0.1%
25.57	17	< 0.1%
15.22	17	< 0.1%
2.85	17	< 0.1%
Other values (7077)	41613	29.5%
(Missing)	16250	11.5%

Value	Count	Frequency (%)
0	83229	58.9%
0.26	5	< 0.1%
0.27	9	< 0.1%
0.28	7	< 0.1%
0.29	3	< 0.1%
0.3	9	< 0.1%
0.31	2	< 0.1%
0.32	4	< 0.1%
0.33	6	< 0.1%
0.34	3	< 0.1%

Value	Count	Frequency (%)
74.99	1	< 0.1%
74.98	3	< 0.1%
74.97	2	< 0.1%
74.95	2	< 0.1%
74.94	4	< 0.1%
74.93	3	< 0.1%
74.92	1	< 0.1%
74.91	1	< 0.1%
74.9	2	< 0.1%
74.89	2	< 0.1%

MP_Settled_Amount
Real number (ℝ)

High correlation Missing

Distinct	113685
Distinct (%)	90.9%
Missing	16250
Missing (%)	11.5%
Infinite	0
Infinite (%)	0.0%
Mean	2486.9651

Minimum	24.84
Maximum	4987.37
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	24.84
5-th percentile	267.5695
Q1	1255.88
median	2486.03
Q3	3715.785
95-th percentile	4704.0705
Maximum	4987.37
Range	4962.53
Interquartile range (IQR)	2459.905

Descriptive statistics

Standard deviation	1421.6569
Coefficient of variation (CV)	0.57164327
Kurtosis	-1.1966635
Mean	2486.9651
Median Absolute Deviation (MAD)	1230.085
Skewness	0.0010518471
Sum	3.1087064 × 10⁸
Variance	2021108.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3598.04	5	< 0.1%
398.52	5	< 0.1%
513	4	< 0.1%
3612.01	4	< 0.1%
257.12	4	< 0.1%
2602.42	4	< 0.1%
3613.72	4	< 0.1%
1660.32	4	< 0.1%
4664.19	4	< 0.1%
1439.83	4	< 0.1%
Other values (113675)	124958	88.5%
(Missing)	16250	11.5%

Value	Count	Frequency (%)
24.84	1	< 0.1%
24.85	1	< 0.1%
24.89	1	< 0.1%
24.96	1	< 0.1%
25.1	1	< 0.1%
25.11	1	< 0.1%
25.12	1	< 0.1%
25.26	1	< 0.1%
25.28	1	< 0.1%
25.31	2	< 0.1%

Value	Count	Frequency (%)
4987.37	1	< 0.1%
4987.35	1	< 0.1%
4987.11	1	< 0.1%
4987.04	1	< 0.1%
4986.94	1	< 0.1%
4986.78	2	< 0.1%
4986.68	1	< 0.1%
4986.35	1	< 0.1%
4986.34	1	< 0.1%
4986.23	1	< 0.1%

MP_Settlement_Date
Date

Missing

Distinct	65
Distinct (%)	0.1%
Missing	16250
Missing (%)	11.5%
Memory size	1.1 MiB

Minimum	2025-01-02 00:00:00
Maximum	2025-04-02 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

MP_Settlement_Batch
Text

Missing

Distinct	2250
Distinct (%)	1.8%
Missing	16250
Missing (%)	11.5%
Memory size	9.9 MiB

Length

Max length	38
Median length	32
Mean length	30.010328
Min length	26

Characters and Unicode

Total characters	3751291
Distinct characters	41
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SET-20250130-PayPal-N/A-USD
2nd row	SET-20250110-GoCardless-N/A-USD
3rd row	SET-20250221-GoCardless-N/A-USD
4th row	SET-20250104-ClientLine-Visa-GBP
5th row	SET-20250316-PayPal-N/A-USD

Value	Count	Frequency (%)
set-20250120-paypal-n/a-usd	318	0.3%
set-20250202-paypal-n/a-usd	316	0.3%
set-20250316-paypal-n/a-usd	311	0.2%
set-20250210-gocardless-n/a-usd	311	0.2%
set-20250313-gocardless-n/a-usd	311	0.2%
set-20250102-paypal-n/a-usd	310	0.2%
set-20250112-paypal-n/a-usd	309	0.2%
set-20250121-paypal-n/a-usd	309	0.2%
set-20250101-paypal-n/a-usd	308	0.2%
set-20250214-paypal-n/a-usd	307	0.2%
Other values (2240)	121890	97.5%

Most occurring characters

Value	Count	Frequency (%)
-	500000	13.3%
2	341956	9.1%
0	298474	8.0%
S	200092	5.3%
a	166945	4.5%
E	143598	3.8%
e	139133	3.7%
5	137569	3.7%
A	129778	3.5%
T	125000	3.3%
Other values (31)	1568746	41.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3751291	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	500000	13.3%
2	341956	9.1%
0	298474	8.0%
S	200092	5.3%
a	166945	4.5%
E	143598	3.8%
e	139133	3.7%
5	137569	3.7%
A	129778	3.5%
T	125000	3.3%
Other values (31)	1568746	41.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3751291	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	500000	13.3%
2	341956	9.1%
0	298474	8.0%
S	200092	5.3%
a	166945	4.5%
E	143598	3.8%
e	139133	3.7%
5	137569	3.7%
A	129778	3.5%
T	125000	3.3%
Other values (31)	1568746	41.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3751291	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	500000	13.3%
2	341956	9.1%
0	298474	8.0%
S	200092	5.3%
a	166945	4.5%
E	143598	3.8%
e	139133	3.7%
5	137569	3.7%
A	129778	3.5%
T	125000	3.3%
Other values (31)	1568746	41.8%

MP_Trx_Currency
Categorical

High correlation Missing

Distinct	5
Distinct (%)	< 0.1%
Missing	16250
Missing (%)	11.5%
Memory size	7.1 MiB

USD	75092
EUR	18598
GBP	12455
AUD	10059
CAD	8796

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	375000
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	USD
2nd row	USD
3rd row	USD
4th row	GBP
5th row	USD

Common Values

Value	Count	Frequency (%)
USD	75092	53.2%
EUR	18598	13.2%
GBP	12455	8.8%
AUD	10059	7.1%
CAD	8796	6.2%
(Missing)	16250	11.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
usd	75092	60.1%
eur	18598	14.9%
gbp	12455	10.0%
aud	10059	8.0%
cad	8796	7.0%

Most occurring characters

Value	Count	Frequency (%)
U	103749	27.7%
D	93947	25.1%
S	75092	20.0%
A	18855	5.0%
E	18598	5.0%
R	18598	5.0%
G	12455	3.3%
B	12455	3.3%
P	12455	3.3%
C	8796	2.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	375000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
U	103749	27.7%
D	93947	25.1%
S	75092	20.0%
A	18855	5.0%
E	18598	5.0%
R	18598	5.0%
G	12455	3.3%
B	12455	3.3%
P	12455	3.3%
C	8796	2.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	375000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
U	103749	27.7%
D	93947	25.1%
S	75092	20.0%
A	18855	5.0%
E	18598	5.0%
R	18598	5.0%
G	12455	3.3%
B	12455	3.3%
P	12455	3.3%
C	8796	2.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	375000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
U	103749	27.7%
D	93947	25.1%
S	75092	20.0%
A	18855	5.0%
E	18598	5.0%
R	18598	5.0%
G	12455	3.3%
B	12455	3.3%
P	12455	3.3%
C	8796	2.3%

MP_Order_ID
Text

Missing

Distinct	125000
Distinct (%)	100.0%
Missing	16250
Missing (%)	11.5%
Memory size	7.6 MiB

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	1375000
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	125000 ?
Unique (%)	100.0%

Sample

1st row	PAY-0000000
2nd row	PAY-0000001
3rd row	PAY-0000002
4th row	PAY-0000003
5th row	PAY-0000004

Value	Count	Frequency (%)
pay-0083344	1	< 0.1%
pay-0000002	1	< 0.1%
pay-0000004	1	< 0.1%
pay-0000005	1	< 0.1%
pay-0000006	1	< 0.1%
pay-0000007	1	< 0.1%
pay-0000008	1	< 0.1%
pay-0000009	1	< 0.1%
pay-0000010	1	< 0.1%
pay-0000011	1	< 0.1%
Other values (124990)	124990	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
0	295500	21.5%
P	125000	9.1%
A	125000	9.1%
Y	125000	9.1%
-	125000	9.1%
1	95500	6.9%
2	65500	4.8%
3	60500	4.4%
4	60500	4.4%
8	59500	4.3%
Other values (4)	238000	17.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1375000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	295500	21.5%
P	125000	9.1%
A	125000	9.1%
Y	125000	9.1%
-	125000	9.1%
1	95500	6.9%
2	65500	4.8%
3	60500	4.4%
4	60500	4.4%
8	59500	4.3%
Other values (4)	238000	17.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1375000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	295500	21.5%
P	125000	9.1%
A	125000	9.1%
Y	125000	9.1%
-	125000	9.1%
1	95500	6.9%
2	65500	4.8%
3	60500	4.4%
4	60500	4.4%
8	59500	4.3%
Other values (4)	238000	17.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1375000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	295500	21.5%
P	125000	9.1%
A	125000	9.1%
Y	125000	9.1%
-	125000	9.1%
1	95500	6.9%
2	65500	4.8%
3	60500	4.4%
4	60500	4.4%
8	59500	4.3%
Other values (4)	238000	17.3%

PG_MP_Match
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	138.1 KiB

True	125000
False	16250

Value	Count	Frequency (%)
True	125000	88.5%
False	16250	11.5%

Bank_Deposit_Date
Date

Missing

Distinct	63
Distinct (%)	0.1%
Missing	20362
Missing (%)	14.4%
Memory size	1.1 MiB

Minimum	2025-01-03 00:00:00
Maximum	2025-04-01 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Bank_Deposit_Currency
Categorical

High correlation Missing

Distinct	5
Distinct (%)	< 0.1%
Missing	20362
Missing (%)	14.4%
Memory size	7.1 MiB

USD	72643
EUR	17956
GBP	12059
AUD	9725
CAD	8505

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	362664
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	USD
2nd row	USD
3rd row	USD
4th row	GBP
5th row	USD

Common Values

Value	Count	Frequency (%)
USD	72643	51.4%
EUR	17956	12.7%
GBP	12059	8.5%
AUD	9725	6.9%
CAD	8505	6.0%
(Missing)	20362	14.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
usd	72643	60.1%
eur	17956	14.9%
gbp	12059	10.0%
aud	9725	8.0%
cad	8505	7.0%

Most occurring characters

Value	Count	Frequency (%)
U	100324	27.7%
D	90873	25.1%
S	72643	20.0%
A	18230	5.0%
E	17956	5.0%
R	17956	5.0%
G	12059	3.3%
B	12059	3.3%
P	12059	3.3%
C	8505	2.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	362664	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
U	100324	27.7%
D	90873	25.1%
S	72643	20.0%
A	18230	5.0%
E	17956	5.0%
R	17956	5.0%
G	12059	3.3%
B	12059	3.3%
P	12059	3.3%
C	8505	2.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	362664	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
U	100324	27.7%
D	90873	25.1%
S	72643	20.0%
A	18230	5.0%
E	17956	5.0%
R	17956	5.0%
G	12059	3.3%
B	12059	3.3%
P	12059	3.3%
C	8505	2.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	362664	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
U	100324	27.7%
D	90873	25.1%
S	72643	20.0%
A	18230	5.0%
E	17956	5.0%
R	17956	5.0%
G	12059	3.3%
B	12059	3.3%
P	12059	3.3%
C	8505	2.3%

Bank_Deposit_Ref_Number
Text

Missing

Distinct	2175
Distinct (%)	1.8%
Missing	20362
Missing (%)	14.4%
Memory size	9.7 MiB

Length

Max length	38
Median length	32
Mean length	30.008669
Min length	26

Characters and Unicode

Total characters	3627688
Distinct characters	41
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SET-20250130-PayPal-N/A-USD
2nd row	SET-20250110-GoCardless-N/A-USD
3rd row	SET-20250221-GoCardless-N/A-USD
4th row	SET-20250104-ClientLine-Visa-GBP
5th row	SET-20250316-PayPal-N/A-USD

Value	Count	Frequency (%)
set-20250120-paypal-n/a-usd	318	0.3%
set-20250202-paypal-n/a-usd	316	0.3%
set-20250313-gocardless-n/a-usd	311	0.3%
set-20250210-gocardless-n/a-usd	311	0.3%
set-20250316-paypal-n/a-usd	311	0.3%
set-20250102-paypal-n/a-usd	310	0.3%
set-20250112-paypal-n/a-usd	309	0.3%
set-20250121-paypal-n/a-usd	309	0.3%
set-20250101-paypal-n/a-usd	308	0.3%
set-20250214-paypal-n/a-usd	307	0.3%
Other values (2165)	117778	97.4%

Most occurring characters

Value	Count	Frequency (%)
-	483552	13.3%
2	332380	9.2%
0	288873	8.0%
S	193531	5.3%
a	161527	4.5%
E	138844	3.8%
e	134480	3.7%
5	133457	3.7%
A	125490	3.5%
T	120888	3.3%
Other values (31)	1514666	41.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3627688	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	483552	13.3%
2	332380	9.2%
0	288873	8.0%
S	193531	5.3%
a	161527	4.5%
E	138844	3.8%
e	134480	3.7%
5	133457	3.7%
A	125490	3.5%
T	120888	3.3%
Other values (31)	1514666	41.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3627688	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	483552	13.3%
2	332380	9.2%
0	288873	8.0%
S	193531	5.3%
a	161527	4.5%
E	138844	3.8%
e	134480	3.7%
5	133457	3.7%
A	125490	3.5%
T	120888	3.3%
Other values (31)	1514666	41.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3627688	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	483552	13.3%
2	332380	9.2%
0	288873	8.0%
S	193531	5.3%
a	161527	4.5%
E	138844	3.8%
e	134480	3.7%
5	133457	3.7%
A	125490	3.5%
T	120888	3.3%
Other values (31)	1514666	41.8%

Bank_Credits
Real number (ℝ)

High correlation Missing

Distinct	2175
Distinct (%)	1.8%
Missing	20362
Missing (%)	14.4%
Infinite	0
Infinite (%)	0.0%
Mean	325334.82

Minimum	5028.22
Maximum	749550.42
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.1 MiB

Quantile statistics

Minimum	5028.22
5-th percentile	32212.59
Q1	100151.47
median	205686.24
Q3	604922.26
95-th percentile	677149.72
Maximum	749550.42
Range	744522.2
Interquartile range (IQR)	504770.79

Descriptive statistics

Standard deviation	249719.87
Coefficient of variation (CV)	0.76757805
Kurtosis	-1.6789828
Mean	325334.82
Median Absolute Deviation (MAD)	157108.97
Skewness	0.31218339
Sum	3.9329076 × 10¹⁰
Variance	6.2360012 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
749550.42	318	0.2%
652986.91	316	0.2%
697204.32	311	0.2%
681556.78	311	0.2%
709519.97	311	0.2%
651192.52	310	0.2%
684456.26	309	0.2%
695829.1	309	0.2%
678343.79	308	0.2%
684766.63	307	0.2%
Other values (2165)	117778	83.4%
(Missing)	20362	14.4%

Value	Count	Frequency (%)
5028.22	4	< 0.1%
5239.3	6	< 0.1%
5700.37	7	< 0.1%
5851.66	3	< 0.1%
6105.74	5	< 0.1%
6537.55	4	< 0.1%
7265.99	4	< 0.1%
7395.72	9	< 0.1%
8551.64	4	< 0.1%
8736.6	6	< 0.1%

Value	Count	Frequency (%)
749550.42	318	0.2%
711543.33	301	0.2%
709519.97	311	0.2%
708968.47	289	0.2%
701886.7	302	0.2%
701471.09	305	0.2%
700747.49	296	0.2%
697204.32	311	0.2%
696299.76	292	0.2%
695829.1	309	0.2%

Bank_Debits
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	20362
Missing (%)	14.4%
Memory size	7.1 MiB

0.0	120888

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	362664
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	120888	85.6%
(Missing)	20362	14.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	120888	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	241776	66.7%
.	120888	33.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	362664	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	241776	66.7%
.	120888	33.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	362664	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	241776	66.7%
.	120888	33.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	362664	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	241776	66.7%
.	120888	33.3%

end_to_end_recon_match
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	138.1 KiB

True	120888
False	20362

Value	Count	Frequency (%)
True	120888	85.6%
False	20362	14.4%

Interactions

Correlations

	BS_Amount	BS_Card_Type	BS_Currency	BS_Foreign_Exchange_Rate	BS_GW_Match	BS_Payment_Gateway	BS_Payment_Method_Type	BS_Processor_Response_Message	BS_Record_Type	BS_Sales_Channel	Bank_Credits	Bank_Deposit_Currency	GW_Card_Brand	GW_Net_Settled_Amt	GW_Transaction_Amount	GW_Trx_Currency	GW_fees	GW_name	MP_Processor_Fee	MP_Processor_Type	MP_Settled_Amount	MP_Trx_Currency	PG_MP_Match	end_to_end_recon_match
BS_Amount	1.000	0.003	0.004	-0.003	1.000	0.000	0.000	0.577	0.577	0.003	0.012	0.002	0.003	1.000	1.000	0.002	0.760	0.000	0.126	0.000	1.000	0.002	0.956	0.840
BS_Card_Type	0.003	1.000	0.002	0.002	0.000	1.000	1.000	0.000	0.000	0.000	0.404	0.000	1.000	0.006	0.003	0.000	0.359	1.000	0.510	1.000	0.013	0.000	0.000	0.000
BS_Currency	0.004	0.002	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.489	1.000	0.000	0.003	0.004	1.000	0.000	0.000	0.000	0.000	0.003	1.000	0.000	0.000
BS_Foreign_Exchange_Rate	-0.003	0.002	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	-0.090	1.000	0.000	-0.007	-0.007	1.000	-0.004	0.000	-0.001	0.000	-0.006	1.000	0.000	0.000
BS_GW_Match	1.000	0.000	0.000	0.000	1.000	0.000	0.000	1.000	1.000	0.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	0.956	0.840
BS_Payment_Gateway	0.000	1.000	0.000	0.000	0.000	1.000	1.000	0.000	0.000	0.000	0.570	0.000	1.000	0.007	0.000	0.000	0.508	1.000	0.640	1.000	0.018	0.000	0.002	0.002
BS_Payment_Method_Type	0.000	1.000	0.000	0.000	0.000	1.000	1.000	0.000	0.000	0.000	0.570	0.000	1.000	0.007	0.000	0.000	0.508	1.000	0.640	1.000	0.018	0.000	0.002	0.002
BS_Processor_Response_Message	0.577	0.000	0.000	0.000	1.000	0.000	0.000	1.000	1.000	0.000	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.001	1.000	1.000	1.000	1.000	1.000	0.879
BS_Record_Type	0.577	0.000	0.000	0.000	1.000	0.000	0.000	1.000	1.000	0.000	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.001	1.000	1.000	1.000	1.000	1.000	0.879
BS_Sales_Channel	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.004	0.004	0.000	0.004	0.000	0.004	0.000	0.004	0.000	0.000	0.000
Bank_Credits	0.012	0.404	0.489	-0.090	1.000	0.570	0.570	1.000	1.000	0.000	1.000	0.489	0.404	0.013	0.012	0.489	-0.166	0.570	-0.417	0.466	0.017	0.489	1.000	1.000
Bank_Deposit_Currency	0.002	0.000	1.000	1.000	1.000	0.000	0.000	1.000	1.000	0.000	0.489	1.000	0.000	0.001	0.002	1.000	0.000	0.000	0.000	0.000	0.002	1.000	1.000	1.000
GW_Card_Brand	0.003	1.000	0.000	0.000	1.000	1.000	1.000	0.000	0.000	0.000	0.404	0.000	1.000	0.006	0.003	0.000	0.359	1.000	0.510	1.000	0.013	0.000	0.000	0.002
GW_Net_Settled_Amt	1.000	0.006	0.003	-0.007	1.000	0.007	0.007	0.000	0.000	0.004	0.013	0.001	0.006	1.000	1.000	0.003	0.756	0.007	0.122	0.006	1.000	0.003	0.000	0.000
GW_Transaction_Amount	1.000	0.003	0.004	-0.007	1.000	0.000	0.000	0.000	0.000	0.004	0.012	0.002	0.003	1.000	1.000	0.004	0.760	0.000	0.126	0.000	1.000	0.004	0.000	0.000
GW_Trx_Currency	0.002	0.000	1.000	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.489	1.000	0.000	0.003	0.004	1.000	0.000	0.000	0.000	0.000	0.003	1.000	0.000	0.000
GW_fees	0.760	0.359	0.000	-0.004	1.000	0.508	0.508	0.000	0.000	0.004	-0.166	0.000	0.359	0.756	0.760	0.000	1.000	0.508	0.517	0.415	0.751	0.000	0.000	0.000
GW_name	0.000	1.000	0.000	0.000	1.000	1.000	1.000	0.001	0.001	0.000	0.570	0.000	1.000	0.007	0.000	0.000	0.508	1.000	0.640	1.000	0.018	0.000	0.001	0.004
MP_Processor_Fee	0.126	0.510	0.000	-0.001	1.000	0.640	0.640	1.000	1.000	0.004	-0.417	0.000	0.510	0.122	0.126	0.000	0.517	0.640	1.000	0.589	0.111	0.000	1.000	0.000
MP_Processor_Type	0.000	1.000	0.000	0.000	1.000	1.000	1.000	1.000	1.000	0.000	0.466	0.000	1.000	0.006	0.000	0.000	0.415	1.000	0.589	1.000	0.015	0.000	1.000	0.004
MP_Settled_Amount	1.000	0.013	0.003	-0.006	1.000	0.018	0.018	1.000	1.000	0.004	0.017	0.002	0.013	1.000	1.000	0.003	0.751	0.018	0.111	0.015	1.000	0.003	1.000	0.000
MP_Trx_Currency	0.002	0.000	1.000	1.000	1.000	0.000	0.000	1.000	1.000	0.000	0.489	1.000	0.000	0.003	0.004	1.000	0.000	0.000	0.000	0.000	0.003	1.000	1.000	0.000
PG_MP_Match	0.956	0.000	0.000	0.000	0.956	0.002	0.002	1.000	1.000	0.000	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.001	1.000	1.000	1.000	1.000	1.000	0.878
end_to_end_recon_match	0.840	0.000	0.000	0.000	0.840	0.002	0.002	0.879	0.879	0.000	1.000	1.000	0.002	0.000	0.000	0.000	0.000	0.004	0.000	0.004	0.000	0.000	0.878	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	BS_Record_Type	BS_Transaction_Date	BS_Currency	BS_Customer_Number	BS_Amount	BS_Payment_Method_Type	BS_Card_Type	BS_Processor_Transaction_Id	BS_Payment_Gateway	BS_Processor_Response_Message	BS_Inv_Payment_Number	BS_Sales_Channel	BS_Foreign_Exchange_Rate	GW_Transaction_ID	GW_name	GW_Transaction_Status	GW_Response	GW_Transaction_Amount	GW_Trx_Currency	GW_Trx_Type	GW_Card_Brand	GW_fees	GW_Net_Settled_Amt	GW_Trx_Date	GW_Ref_Number	BS_GW_Match	MP_Trx_ID	MP_Processor_Type	MP_Trx_Type	MP_Processor_Fee	MP_Settled_Amount	MP_Settlement_Date	MP_Settlement_Batch	MP_Trx_Currency	MP_Order_ID	PG_MP_Match	Bank_Deposit_Date	Bank_Deposit_Currency	Bank_Deposit_Ref_Number	Bank_Credits	end_to_end_recon_match
0	payment	2025-01-30	USD	CUST15159	2592.98	PayPal	PayPal	PROC-21233551	PayPal	Approved	PAY-0000000	In-Store	1.0017	GW-TRX-9972261	PayPal	settled	Approved	2592.98	USD	payment	PayPal	19.45	2573.53	2025-01-30	PAY-0000000	Yes	PROC-TRX-96148747	PayPal	payment	0.00	2573.53	2025-01-31	SET-20250130-PayPal-N/A-USD	USD	PAY-0000000	Yes	2025-02-03	USD	SET-20250130-PayPal-N/A-USD	584871.77	Yes
1	payment	2025-01-10	USD	CUST20779	4277.28	ACH	ACH	PROC-45142454	GoCardless	Approved	PAY-0000001	In-Store	1.0058	GW-TRX-8455695	GoCardless	settled	Approved	4277.28	USD	payment	GoCardless	10.69	4266.59	2025-01-10	PAY-0000001	Yes	PROC-TRX-53756634	GoCardless	payment	0.00	4266.59	2025-01-13	SET-20250110-GoCardless-N/A-USD	USD	PAY-0000001	Yes	2025-01-14	USD	SET-20250110-GoCardless-N/A-USD	621022.33	Yes
2	payment	2025-02-21	USD	CUST28404	2515.78	ACH	ACH	PROC-76309118	GoCardless	Approved	PAY-0000002	Phone	1.0056	GW-TRX-5184318	GoCardless	settled	Approved	2515.78	USD	payment	GoCardless	6.29	2509.49	2025-02-21	PAY-0000002	Yes	PROC-TRX-96643401	GoCardless	payment	0.00	2509.49	2025-02-24	SET-20250221-GoCardless-N/A-USD	USD	PAY-0000002	Yes	2025-02-25	USD	SET-20250221-GoCardless-N/A-USD	655334.98	Yes
3	payment	2025-01-04	GBP	CUST7007	2874.81	Credit Card	Visa	PROC-62839998	Cybersource	Approved	PAY-0000003	Phone	1.2599	GW-TRX-8104962	Cybersource	settled	Approved	2874.81	GBP	payment	Visa	28.75	2846.06	2025-01-04	PAY-0000003	Yes	PROC-TRX-48503361	ClientLine	payment	28.75	2817.31	2025-01-07	SET-20250104-ClientLine-Visa-GBP	GBP	PAY-0000003	Yes	2025-01-08	GBP	SET-20250104-ClientLine-Visa-GBP	38585.64	Yes
4	payment	2025-03-16	USD	CUST39746	350.01	PayPal	PayPal	PROC-62414033	PayPal	Approved	PAY-0000004	In-Store	1.0060	GW-TRX-2770667	PayPal	settled	Approved	350.01	USD	payment	PayPal	2.63	347.38	2025-03-16	PAY-0000004	Yes	PROC-TRX-87613870	PayPal	payment	0.00	347.38	2025-03-19	SET-20250316-PayPal-N/A-USD	USD	PAY-0000004	Yes	2025-03-20	USD	SET-20250316-PayPal-N/A-USD	681556.78	Yes
5	payment	2025-02-10	USD	CUST3055	4412.91	Credit Card	Mastercard	PROC-58248354	Cybersource	Approved	PAY-0000005	Online	1.0076	GW-TRX-8558984	Cybersource	settled	Approved	4412.91	USD	payment	Mastercard	44.13	4368.78	2025-02-10	PAY-0000005	Yes	PROC-TRX-40189275	ClientLine	payment	44.13	4324.65	2025-02-11	SET-20250210-ClientLine-Mastercard-USD	USD	PAY-0000005	Yes	2025-02-12	USD	SET-20250210-ClientLine-Mastercard-USD	138689.96	Yes
6	payment	2025-02-07	AUD	CUST6360	399.15	ACH	ACH	PROC-58711045	GoCardless	Approved	PAY-0000006	In-Store	0.6555	GW-TRX-5053867	GoCardless	settled	Approved	399.15	AUD	payment	GoCardless	1.00	398.15	2025-02-07	PAY-0000006	Yes	PROC-TRX-13724055	GoCardless	payment	0.00	398.15	2025-02-10	SET-20250207-GoCardless-N/A-AUD	AUD	PAY-0000006	Yes	2025-02-11	AUD	SET-20250207-GoCardless-N/A-AUD	89870.35	Yes
7	payment	2025-02-20	GBP	CUST44856	1639.12	ACH	ACH	PROC-99846281	GoCardless	Approved	PAY-0000007	In-Store	1.2759	GW-TRX-1689560	GoCardless	settled	Approved	1639.12	GBP	payment	GoCardless	4.10	1635.02	2025-02-20	PAY-0000007	Yes	PROC-TRX-57320369	GoCardless	payment	0.00	1635.02	2025-02-21	SET-20250220-GoCardless-N/A-GBP	GBP	PAY-0000007	Yes	2025-02-24	GBP	SET-20250220-GoCardless-N/A-GBP	71271.86	Yes
8	payment	2025-02-25	USD	CUST8902	802.45	Credit Card	Amex	PROC-65593396	Cybersource	Approved	PAY-0000008	Online	1.0027	GW-TRX-5187601	Cybersource	settled	Approved	802.45	USD	payment	Amex	8.02	794.43	2025-02-25	PAY-0000008	Yes	PROC-TRX-36380772	Amex	payment	12.04	782.39	2025-02-26	SET-20250225-Amex-Amex-USD	USD	PAY-0000008	Yes	2025-02-27	USD	SET-20250225-Amex-Amex-USD	235013.68	Yes
9	payment	2025-02-23	USD	CUST16887	4780.71	Credit Card	Mastercard	PROC-56406364	Cybersource	Approved	PAY-0000009	Online	0.9977	GW-TRX-8963563	Cybersource	settled	Approved	4780.71	USD	payment	Mastercard	47.81	4732.90	2025-02-23	PAY-0000009	Yes	PROC-TRX-55314596	ClientLine	payment	47.81	4685.09	2025-02-26	SET-20250223-ClientLine-Mastercard-USD	USD	PAY-0000009	Yes	2025-02-27	USD	SET-20250223-ClientLine-Mastercard-USD	178556.96	Yes

	BS_Record_Type	BS_Transaction_Date	BS_Currency	BS_Customer_Number	BS_Amount	BS_Payment_Method_Type	BS_Card_Type	BS_Processor_Transaction_Id	BS_Payment_Gateway	BS_Processor_Response_Code	BS_Processor_Response_Message	BS_Inv_Payment_Number	BS_Sales_Channel	BS_Foreign_Exchange_Rate	GW_Transaction_ID	GW_name	GW_Transaction_Status	GW_Response_Code	GW_Response	GW_Transaction_Amount	GW_Trx_Currency	GW_Trx_Type	GW_Card_Brand	GW_fees	GW_Net_Settled_Amt	GW_Trx_Date	GW_Ref_Number	BS_GW_Match	MP_Trx_ID	MP_Processor_Type	MP_Trx_Type	MP_Processor_Fee	MP_Settled_Amount	MP_Settlement_Date	MP_Settlement_Batch	MP_Trx_Currency	MP_Order_ID	PG_MP_Match	Bank_Deposit_Date	Bank_Deposit_Currency	Bank_Deposit_Ref_Number	Bank_Credits	Bank_Debits	end_to_end_recon_match
141240	chargeback_reversal	2025-03-26	USD	CUST35141	689.24	ACH	ACH	PROC-27835908	GoCardless	C02	Chargeback Reversed	PAY-0107910	In-Store	0.9972	GW-TRX-2559292	GoCardless	settled	00	Approved	689.24	USD	payment	GoCardless	1.72	687.52	2025-03-26	PAY-0107910	Yes	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	No	NaN	NaN	NaN	NaN	NaN	No
141241	chargeback_reversal	2025-03-06	USD	CUST38615	2318.44	Credit Card	Mastercard	PROC-12729812	Cybersource	C02	Chargeback Reversed	PAY-0024103	In-Store	0.9920	GW-TRX-7827390	Cybersource	settled	0	Approved	2318.44	USD	payment	Mastercard	23.18	2295.26	2025-03-06	PAY-0024103	Yes	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	No	NaN	NaN	NaN	NaN	NaN	No
141242	chargeback_reversal	2025-03-11	CAD	CUST33012	4353.13	Credit Card	Amex	PROC-47353736	Cybersource	C02	Chargeback Reversed	PAY-0039969	In-Store	0.7286	GW-TRX-4868451	Cybersource	settled	0	Approved	4353.13	CAD	payment	Amex	43.53	4309.60	2025-03-11	PAY-0039969	Yes	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	No	NaN	NaN	NaN	NaN	NaN	No
141243	chargeback_reversal	2025-01-31	GBP	CUST29916	28.61	PayPal	PayPal	PROC-65209114	PayPal	C02	Chargeback Reversed	PAY-0101060	Online	1.2621	GW-TRX-2579080	PayPal	settled	00	Approved	28.61	GBP	payment	PayPal	0.21	28.40	2025-01-31	PAY-0101060	Yes	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	No	NaN	NaN	NaN	NaN	NaN	No
141244	chargeback_reversal	2025-01-24	USD	CUST20753	2263.30	ACH	ACH	PROC-90546965	GoCardless	C02	Chargeback Reversed	PAY-0020178	Online	0.9962	GW-TRX-6667190	GoCardless	settled	0	Approved	2263.30	USD	payment	GoCardless	5.66	2257.64	2025-01-24	PAY-0020178	Yes	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	No	NaN	NaN	NaN	NaN	NaN	No
141245	chargeback_reversal	2025-03-12	USD	CUST16969	2573.44	ACH	ACH	PROC-65330212	GoCardless	C02	Chargeback Reversed	PAY-0025245	Online	0.9928	GW-TRX-4965129	GoCardless	settled	0	Approved	2573.44	USD	payment	GoCardless	6.43	2567.01	2025-03-12	PAY-0025245	Yes	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	No	NaN	NaN	NaN	NaN	NaN	No
141246	chargeback_reversal	2025-01-01	EUR	CUST33287	794.03	Credit Card	Amex	PROC-79034160	Cybersource	C02	Chargeback Reversed	PAY-0093761	Online	1.0854	GW-TRX-9449979	Cybersource	settled	0	Approved	794.03	EUR	payment	Amex	7.94	786.09	2025-01-01	PAY-0093761	Yes	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	No	NaN	NaN	NaN	NaN	NaN	No
141247	chargeback_reversal	2025-02-13	USD	CUST12112	3629.53	PayPal	PayPal	PROC-53163760	PayPal	C02	Chargeback Reversed	PAY-0103102	Online	0.9919	GW-TRX-7642246	PayPal	settled	00	Approved	3629.53	USD	payment	PayPal	27.22	3602.31	2025-02-13	PAY-0103102	Yes	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	No	NaN	NaN	NaN	NaN	NaN	No
141248	chargeback_reversal	2025-02-10	USD	CUST27487	2700.28	Credit Card	Mastercard	PROC-29829469	Cybersource	C02	Chargeback Reversed	PAY-0039089	Phone	0.9963	GW-TRX-5426672	Cybersource	settled	0	Approved	2700.28	USD	payment	Mastercard	27.00	2673.28	2025-02-10	PAY-0039089	Yes	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	No	NaN	NaN	NaN	NaN	NaN	No
141249	chargeback_reversal	2025-01-05	CAD	CUST23398	2500.12	ACH	ACH	PROC-69324390	GoCardless	C02	Chargeback Reversed	PAY-0022422	Online	0.7254	GW-TRX-9447663	GoCardless	settled	0	Approved	2500.12	CAD	payment	GoCardless	6.25	2493.87	2025-01-05	PAY-0022422	Yes	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	No	NaN	NaN	NaN	NaN	NaN	No

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category